Data Engineering5

How I ran the modern data stack — ClickHouse, dbt, Dagster, Iceberg — self-hosted on Hetzner for under €200/month instead of €1,000+ managed.

How I structure a dbt Core project against ClickHouse — staging/intermediate/marts, layer-per-database, incremental models, and the ClickHouse-specific gotchas.

Why I run ClickHouse on a dedicated box instead of Kubernetes, the trade-offs, and how to back it up without corrupting your MergeTree parts.

A bare humidity number doesn't tell you when a cellar will condense. I added a cheap Tapo T310 to my H100 hub and turned it into a dew-point mold early-warning.

My inverter cloud shows self-consumption and autarky as pretty graphs. Home Assistant gives you raw counters. Here's how I rebuilt those numbers as template sensors I own.